
UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_CTRL_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

CREATE TABLE FLW_CTRL_AUDIT_LOG (ID_ VARCHAR2(255) NOT NULL, CLUSTER_ID_ VARCHAR2(255), CREATED_BY_ VARCHAR2(255), CREATED_ON_ TIMESTAMP(6), TENANT_ID_ VARCHAR2(255), TYPE_ VARCHAR2(255), SUB_TYPE_ VARCHAR2(255), PAYLOAD_ CLOB, CONSTRAINT PK_FLW_CTRL_AUDIT_LOG PRIMARY KEY (ID_));

INSERT INTO FLW_CTRL_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('6', 'flowable', 'META-INF/liquibase/flowable-control-db-changelog.xml', SYSTIMESTAMP, 6, '8:3de60bd03b9061245d74ee10724df86d', 'createTable tableName=FLW_CTRL_AUDIT_LOG', '', 'EXECUTED', NULL, NULL, '4.11.0', '4241458803');

CREATE TABLE FLW_CTRL_ROLE (ID_ VARCHAR2(255) NOT NULL, NAME_ VARCHAR2(255), PRIVILEGES_ CLOB, CONSTRAINT PK_FLW_CTRL_ROLE PRIMARY KEY (ID_));

CREATE TABLE FLW_CTRL_ROLE_USER_MAPPING (ID_ VARCHAR2(64) NOT NULL, USER_ID_ VARCHAR2(255), ROLE_ID_ VARCHAR2(255), GROUP_ID_ VARCHAR2(255), CONSTRAINT PK_FLW_CTRL_ROLE_USER_MAPPING PRIMARY KEY (ID_));

CREATE INDEX FLW_DE_IDX_PRIVILEGE_GROUP ON FLW_CTRL_ROLE_USER_MAPPING(GROUP_ID_);

CREATE INDEX FLW_DE_IDX_PRIVILEGE_ROLE ON FLW_CTRL_ROLE_USER_MAPPING(ROLE_ID_);

INSERT INTO FLW_CTRL_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('7', 'flowable', 'META-INF/liquibase/flowable-control-db-changelog.xml', SYSTIMESTAMP, 7, '8:429498ea63b2084b296390b18b5da6a6', 'createTable tableName=FLW_CTRL_ROLE; createTable tableName=FLW_CTRL_ROLE_USER_MAPPING; createIndex indexName=FLW_DE_IDX_PRIVILEGE_GROUP, tableName=FLW_CTRL_ROLE_USER_MAPPING; createIndex indexName=FLW_DE_IDX_PRIVILEGE_ROLE, tableName=FLW_CTRL_ROLE...', '', 'EXECUTED', NULL, NULL, '4.11.0', '4241458803');

ALTER TABLE FLW_CTRL_USER ADD CONSTRAINT FLW_CTRL_UNIQ_USERNAME UNIQUE (USERNAME_);

INSERT INTO FLW_CTRL_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('8', 'flowable', 'META-INF/liquibase/flowable-control-db-changelog.xml', SYSTIMESTAMP, 8, '8:088b5c56824fe81d943482a2ac9b7a9e', 'addUniqueConstraint constraintName=FLW_CTRL_UNIQ_USERNAME, tableName=FLW_CTRL_USER', '', 'EXECUTED', NULL, NULL, '4.11.0', '4241458803');

UPDATE FLW_CTRL_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

